

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<script type="text/javascript" src="helpman_topicinit.js"></script>

<title>Adaptive Server Anywhere Repository [Enterprise Architect User Guide]</title>

<meta name="keywords" content="Enterprise Architect, Sparx Systems, UML, Model File,Model File Create Adaptive Server Anywhere Repository,Create,Create Adaptive Server Anywhere Repository,Repository,Repository Adaptive Server Anywhere, Create,Adaptive Server Anywhere,Adaptive Server Anywhere Repository, Create,ASA,ASA Repository, Create">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />

<link type="text/css" href="default.css" rel="stylesheet" />
<style type="text/css">
  A, A:Visited
  {
    color: #00F;
  }

  A:Active, A:Hover
  {
    color: #F00;
  }

  OL
  {
    margin: 5px 0 5px 48px;
  }

  UL
  {
    margin-bottom: 3px;
    margin-top: 0;
  }

  #nsr
  {
    background-color: #D4DFFF;
  }

  #nsr A
  {
    text-decoration: none;
  }

  #mainbody
  {
    padding: 8px;
  }

  .p_BodyText
  {
    padding: 5px 0;
  }
</style>



<style type="text/css" media="screen">
  BODY
  {
    background-color: #FFFFFF;
  }

  #nsr
  {
    padding: 6px 6px 0 6px;
    border-bottom: none;
    vertical-align: top;
    z-index: 2;
    visibility: visible;
    left: 0;
    top: 0;
    position: absolute;
  }

  #mainbody
  {
    left: 0;
    top: 0;
    margin: 0;
    position: absolute;
    padding: 10px;
    overflow: auto;
    height: 100%;
    z-index: 1;
    background-repeat: no-repeat;
    background-position: bottom right;
    background-attachment: fixed;
  }
</style>

<style type="text/css" media="print">
  #nsr
  {
    visibility: none;
  }

  #mainbody
  {
    overflow: visible;
  }
</style>
<script type="text/javascript" language="JavaScript" src="nonscroll.js"></script>

</head>
<body scroll="no">

<div id="page">



        <div id="content">
          <div id="content-inner">
          



  
          <div id="nsr">
            <table border="0" cellspacing="0" cellpadding="4" width="100%">
              <tr valign="top">
                <td align="left">
  


                  <p class="p_Heading1"><span class="f_Heading1">Create an Adaptive Server Anywhere (ASA) Repository</span></p>



  
                </td>
                <td align="right">
                  <a href="introduction.htm" onmouseover="document.images.main.src='button_main_h.gif'" onmouseout="document.images.main.src='button_main.gif'">
                    <img name="main" src="button_main.gif" border=0 alt="Return to Introduction">
                  </a>&nbsp;
    
                  <a href="createanewpostgresqlreposi.htm" onmouseover="document.images.prev.src='button_prev_h.gif'" onmouseout="document.images.prev.src='button_prev.gif'">
                    <img name=prev src="button_prev.gif" border=0 alt="Previous page" />
                  </a>&nbsp;
    
    
    
                  <a href="createanewmsdeserverrepos.htm" onmouseover="document.images.next.src='button_next_h.gif'" onmouseout="document.images.next.src='button_next.gif'">
                    <img name=next src="button_next.gif" border=0 alt="Next page" />
                  </a>
    
    
                </td>
              </tr>
            </table>
          </div>
          <div id="mainbody">
  


                <div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 5px 0px 5px 13px;"><table cellspacing="0" cellpadding="2" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:bottom;">
<td valign="bottom" width="955" bgcolor="#efeff7" style="width:955px; background-color:#efeff7;"><p class="p_TiporNote" style="border-top: none; border-right: none; border-left: none;"><span class="f_TiporNote">Note:</span></p>
</td>
</tr>
<tr style="text-align:left;">
<td width="955" bgcolor="#f7f7ff" style="width:955px; background-color:#f7f7ff;"><p class="p_TiporNoteText"><span class="f_TiporNoteText">This feature is available in the </span><span class="f_TiporNoteText">Corporate, Business and Software Engineering, System Engineering and Ultimate editions.</span></p>
</td>
</tr>
</table>
</div>
<p class="p_BodyText"><span class="f_BodyText">Before creating an ASA data repository in Enterprise Architect, you must set up ASA and ASA ODBC drivers. For further information on setting these up, see <a href="setupanadaptiveserveranywh.htm">Setup an Adaptive Server Anywhere ODBC Driver</a>.</span></p>
<p class="p_BodyText"><span class="f_BodyText">To create a new ASA repository, you must first create a database into which to import the table definitions for Enterprise Architect. Sparx Systems provide SQL scripts to create the required tables - how you create the database and execute that script are up to you.</span></p>
<ul style="text-indent: 0px; margin-left: 30px; list-style-position: outside;">
<li><span class="f_Bulletlist1">Registered users can obtain the scripts from the Registered Corporate edition </span><span class="f_UIControl">Resources</span><span class="f_Bulletlist1"> page of the Sparx Systems website at <a href="http://www.sparxsystems.com/registered/reg_ea_corp_ed.html" target="_blank" class="weblink">www.sparxsystems.com/registered/reg_ea_corp_ed.html</a></span></li>
<li><span class="f_Bulletlist1">Trial users can obtain the scripts from the Corporate edition </span><span class="f_UIControl">Resources</span><span class="f_Bulletlist1"> page of the Sparx Systems website at <a href="http://www.sparxsystems.com/resources/corporate/" target="_blank" class="weblink">http://www.sparxsystems.com/resources/corporate/</a>.</span></li>
</ul>
<p class="p_SubHeadingL1"><span class="f_SubHeadingL1">Create the Data Repository</span><span class="f_SubHeadingL1"> </span></p>
<p class="p_BodyText"><span class="f_BodyText">After you create the database and execute the script, the result should be an empty Enterprise Architect project to begin working with. You can transfer data from an existing .EAP file or simply start from scratch.</span></p>
<p class="p_SubHeadingL2"><span class="f_SubHeadingL2">Third Party Tools</span><span class="f_SubHeadingL2"> </span></p>
<p class="p_BodyText"><span class="f_BodyText">If you are unfamiliar with ASA and DBMS systems in general, you might want to consider a suitable front end tool.</span></p>
<p class="p_BodyText"><span class="f_BodyText">Sybase Central is one such tool, that can be installed along with the DBMS. It provides a convenient graphical user interface to enable creation of databases, execution of scripts and restores.</span></p>
<p class="p_BodyText"><span class="f_BodyText">To get started with Sybase Central, follow the steps below:</span></p>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=1><span class="f_NumberedList">Create a new database.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="sybasecentral1.png" width="518" height="347" border="0" alt="SybaseCentral1"><br>
<span class="f_NumberedList">&nbsp;</span></li>
<li value=2><span class="f_NumberedList">Open and execute the ASA SQL script.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="sybasecentral2.png" width="516" height="348" border="0" alt="SybaseCentral2"><br>
<span class="f_NumberedList">&nbsp;</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="asab_basemodel.png" width="578" height="414" border="0" alt="ASAB_BaseModel"><br>
<span class="f_NumberedList">&nbsp;</span></li>
</ol>
<p class="p_BodyText"><span class="f_BodyText">Below is an example showing the tables created in the ASA repository after running the script in EMS ASA Manager.</span></p>
<p class="p_Bulletlist3"><img src="sybasecentral3.png" width="513" height="465" border="0" alt="SybaseCentral3"></p>




            </div>
          </div>
        </div>



</div>


</body>
</html>
